| SaGLBatch |
| Logical Entity Name | SaGLBatch |
| Default Table Name | SaGLBatch |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SaGLBatch Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaGLBatchID |
int | NO | ||
| SyCampusID | int | NO | ||
| BatchNo | char(8) | NO | ||
| LowDate | datetime | YES | ||
| HighDate | datetime | YES | ||
| Status | char(1) | NO | ||
| DateExported | datetime | YES | ||
| ExportFileName | varchar(50) | YES | ||
| ExportUserID | int | YES | ||
| ExportType | char(8) | YES | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
| GLBatchNo | int | NO | ||
SyCampusGrpID |
int | YES | ||
| FileTransferSuccessful | bit | YES | ||
| GL_Entry | varchar(25) | YES | ||
| Period | smallint | YES | ||
| FiscalYear | varchar(5) | YES | ||
SaJournalEntryGrpId |
int | YES | ||
| ExportedDateFormat | varchar(20) | YES | ||
| TransactionType | int | YES | ||
| AxGlBatchNo | nvarchar(max) | YES | ||
| BatchException | varchar(8000) | YES | ||
| HangFireBatchId | varchar(75) | YES | ||
| SaDynamicsProcessLogId | int | YES |
| SaGLBatch Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SaGLBatch_SaGLBatchID_U_C_IDX | PrimaryKey | SaGLBatchID |
| SaGLBatch_SaJournalEntryGrpId_SaGLBatchId_U_N_IDX | Index | SaJournalEntryGrpId, SaGLBatchID |
| SaGLBatch Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| SaJournalEntryGrp | Non-Identifying | Zero or One to Zero or More | FK_SaGLBatch_SaJournalEntryGrpId | SaJournalEntryGrpId | NO | YES | ||
| SyCampusGrp | Non-Identifying | Zero or One to Zero or More | FK_SaGlBatch_SyCampusGrpID_SyCampusGrp_SyCampusGrpID | SyCampusGrpID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaGLBatch Check Constraints |
| Check Constraint Name | CheckConstraint |
| SaGLBatch Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group | PRIMARY |
| SaGLBatch Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.GeneralLedgerReleaseBatch |
NO | |||
| Physical (Microsoft SQL Server) dbo.SaGLBatch |
NO |
| SaGLBatch Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Revenue_GL_BankDeposit |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Student Accounts |
| SaGLBatch Data Movement Rules |
| Name | Type | Rule Text/Value |